翻訳と辞書
Words near each other
・ Data Matrix
・ Data matrix
・ Data matrix (multivariate statistics)
・ Data merge
・ Data migration
・ Data mile
・ Data mining
・ Data Mining and Knowledge Discovery
・ Data Mining Extensions
・ Data mining in agriculture
・ Data mining in meteorology
・ Data model
・ Data constrained modelling
・ Data Control & Systems
・ Data Control Block
Data control language
・ Data conversion
・ Data converter
・ Data corruption
・ Data cube
・ Data curation
・ Data custodian
・ Data de Groove
・ Data deduplication
・ Data deficient
・ Data Defined Storage
・ Data definition language
・ Data definition specification
・ Data degradation
・ Data dependency


Dictionary Lists
翻訳と辞書 辞書検索 [ 開発暫定版 ]
スポンサード リンク

Data control language : ウィキペディア英語版
Data control language

A data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database (Authorization). In particular, it is a component of Structured Query Language (SQL).
Examples of DCL commands include:
* GRANT to allow specified users to perform specified tasks.
* REVOKE to cancel previously granted or denied permissions.
The operations for which privileges may be granted to or revoked from a user or role may include CONNECT, SELECT, INSERT, UPDATE, DELETE, EXECUTE, and USAGE.
In the Oracle database, executing a DCL command issues an implicit commit. Hence you cannot roll back the command.
In PostgreSQL, executing DCL is transactional, and can be rolled back.
==See also==

* Data definition language
* Data manipulation language


抄文引用元・出典: フリー百科事典『 ウィキペディア(Wikipedia)
ウィキペディアで「Data control language」の詳細全文を読む



スポンサード リンク
翻訳と辞書 : 翻訳のためのインターネットリソース

Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.